Dashboard 02 - Creating Cards and Slicer 17


In this step, we will create cards in the 2nd dashboard.


To help you get started, you can copy the following cards from Dashboard 01, RaleighPoliceIncidents, to this dashboard.

Click on the chart/card/slicer, press Ctrl+C to copy and Ctrl+V to paste it. 


Years

Violent Crime Rate

YOY Violent Crime Rate

Major Crime Rate

YOY Major Crime Rate

Select a District

Blank Text Box





Step 1:  Create Crime Category Type Card

In Power BI Desktop, click on the page, RaleighPoliceIncidents-District


Click inside the pane

Click on the 'Select a District', press Ctrl+C to copy and Ctrl+V to paste it. 

From the copied 'Select a District' card from Dashboard 01, RaleighPoliceIncidents, to this dashboard, set up as follows:


Visualizations

Click the Card icon

Fields

Select the following:

A_KeyMeasures ->  .Measure_Crime_Category


Visualizations

Under Fields tab, click on the down arrow ->  Rename for this visual and rename the card to Crime Category 

Under Format ->  General: X Position = 628 , Y Position = 108 , Width = 355 , Height = 36

Under Format ->  Data Label ->  Color = 094780 , Text Size = 19 pt , Font = DIN (default)

Under Format -> Category ->  Set it to OFF

Under Format -> Title ->  Set it to OFF

Under Format ->  Background ->  Set it to ON , Color = CCCCCC




Step 2:  Create Violent Crime Rate Card

Click on the chart/card/slicer, press Ctrl+C to copy and Ctrl+V to paste it. 

From the copied card from Dashboard 01, RaleighPoliceIncidents, to this dashboard, set up as follows:

Visualizations

Click the Card icon

Fields

Select the following:

A_KeyMeasures ->  .Transparent_Violent_CrimeRate%


Visualizations

Under Fields tab, click on the down arrow ->  Rename for this visual and rename the card to Violent Crime Rate 

Under Format ->  General: X Position = 1 , Y Position = 167 , Width = 225 , Height = 160

Under Format ->  Data Label ->  Color = 000000 , Text Size = 28 pt , Font = DIN (default)

Under Format -> Category ->  Set it to ON ->  Color = 000000 , Text Size = 15 pt , Font = Segoe UI

Under Format -> Title ->  Set it to OFF

Under Format ->  Background ->  Set it to ON , Color = E6E6E6

Under Format ->  Border ->  Set it to ON , Color = 666666



Step 3:  Create Major Crime Rate Card

Click on the chart/card/slicer, press Ctrl+C to copy and Ctrl+V to paste it. 

From the copied card from Dashboard 01, RaleighPoliceIncidents, to this dashboard, set up as follows:


Visualizations

Click the Card icon

Fields

Select the following:

A_KeyMeasures ->  .Transparent_Major_CrimeRate%


Visualizations

Under Fields tab, click on the down arrow ->  Rename for this visual and rename the card to Major Crime Rate 

Under Format ->  General: X Position = 1 , Y Position = 604, Width = 225 , Height = 160

Under Format ->  Data Label ->  Color = 000000 , Text Size = 28 pt , Font = DIN (default)

Under Format -> Category ->  Set it to ON ->  Color = 000000 , Text Size = 15 pt , Font = Segoe UI

Under Format -> Title ->  Set it to OFF

Under Format ->  Background ->  Set it to ON , Color = E6E6E6

Under Format ->  Border ->  Set it to ON , Color = 666666







Step 4:  Create Year Over Year (YOY) Violent Crime Rate Card

Click on the chart/card/slicer, press Ctrl+C to copy and Ctrl+V to paste it. 

From the copied card from Dashboard 01, RaleighPoliceIncidents, to this dashboard, set up as follows:


Visualizations

Click the Card icon

Fields

Select the following:

A_KeyMeasures ->  .Transparent_Violent_Crimes_YOY%


Visualizations

Under Fields tab, click on the down arrow ->  Rename for this visual and rename the card to YOY Violent Crime Rate 

Under Format ->  General: X Position = 1 , Y Position = 363 , Width = 225 , Height = 160

Under Format ->  Data Label ->  click fx ->  Format by = Color Scale, Based on Field = .YOY_Violent_CrimeRate% , Minimum = 5B8F22  with a value of 0.00001 , Maximum =   FF0000 with a value of 0 , Text Size = 28 pt , Font = DIN (default)

Under Format -> Category ->  Set it to ON ->  Color = 000000 , Text Size = 15 pt , Font = Segoe UI

Under Format -> Title ->  Set it to OFF

Under Format ->  Background ->  Set it to ON , Color = E6E6E6

Under Format ->  Border ->  Set it to ON , Color = 666666





Step 5:  Create Year Over Year (YOY) Major Crime Rate Card

Click on the chart/card/slicer, press Ctrl+C to copy and Ctrl+V to paste it. 

From the copied card from Dashboard 01, RaleighPoliceIncidents, to this dashboard, set up as follows:


Visualizations

Click the Card icon

Fields

Select the following:

A_KeyMeasures ->  .Transparent_Major_Crimes_YOY%


Visualizations

Under Fields tab, click on the down arrow ->  Rename for this visual and rename the card to YOY Major Crime Rate 

Under Format ->  General: X Position = 1 , Y Position = 787 , Width = 225 , Height = 160

Under Format ->  Data Label ->  click fx ->  Format by = Color Scale, Based on Field = .YOY_Major_CrimeRate% , Minimum = 5B8F22  with a value of 0.00001 , Maximum =   FF0000 with a value of 0 , Text Size = 28 pt , Font = DIN (default)

Under Format -> Category ->  Set it to ON ->  Color = 000000 , Text Size = 15 pt , Font = Segoe UI

Under Format -> Title ->  Set it to OFF

Under Format ->  Background ->  Set it to ON , Color = E6E6E6

Under Format ->  Border ->  Set it to ON , Color = 666666






Step 6:  Create Year Slicer

Click on the chart/card/slicer, press Ctrl+C to copy and Ctrl+V to paste it. 

From the copied card from Dashboard 01, RaleighPoliceIncidents, to this dashboard, set up as follows:

Visualizations

Click the Slicer icon

Fields

Select the following:

Raleigh_Police_Incidents_NIBRS ->  Reported_Date ->  Date Hierarchy ->  Year


Visualizations

Under Fields tab, click on the down arrow ->  Rename for this visual and rename the card to YOY Major Crime Rate 

Under Format ->  General: X Position = 935  , Y Position = 0 , Width = 260 , Height = 108

Under Format ->  Numeric Inputs ->  Font Color = 000000, Text Size = 13 pt , Font = Segoe UI

Under Format -> Slider ->  Set it to ON ->  Color = 094780

Under Format -> Title ->  Set it to ON , Title Text = Years, Font Color = 094780 , Background Color = E6E6E6 , Alignment = Center , Text Size = 17 pt , Font Family = DIN (Default)

Under Format ->  Background ->  Set it to ON , Color = FFF

Under Format ->  Border ->  Set it to ON , Color = 666666




Step 07: Create Last Refreshed Card

Click inside the pane

Visualizations

Click the Card icon

Fields

Select the following:

A_KeyMeasures ->  .Last_Refreshed_(Local)


Visualizations

Under Fields tab, click on the down arrow ->  Rename for this visual and rename the card to Last Refreshed Date

Under Format ->  General: X Position = 1  , Y Position = 65 , Width = 223 , Height = 80

Under Format ->  Data Label ->  Color = 094780 , Text Size = 17 pt , Font = DIN (default)

Under Format -> Category ->  Set it to ON ->  Color = 094780 , Text Size = 20 pt , Font = Segoe UI

Under Format -> Title ->  Set it to OFF

Under Format ->  Background ->  Set it to ON , Color = E6E6E6

Under Format ->  Border ->  Set it to ON , Color = 666666




Step 8 - Move the 'Select a District' card to the following position:

Under Format ->  General: X Position = 983 , Y Position = 108 , Width = 417 , Height = 36


Step 9 - Move the Blank Text Box to the following position:

Under Format ->  General: X Position = 225 , Y Position = 108 , Width = 355 , Height = 36



When finished, save the project.



How to create a Card visualization in Power BI


How to create a Slicer visualization in Power BI